Upgrading to 0.18.0
Upgrade Guides Are Moving
The location of the dbt Core upgrade guides has changed, and they will soon be removed from Guides
. The new location is in the Docs
tab under Available dbt versions
. You have been redirected to the new URL, so please update any saved links and bookmarks.
Resources
Breaking changes
Please be aware of the following changes in v0.18.0. While breaking, we do not expect these to affect the majority of projects.
Adapter macros
- dbt only has access to adapter plugin macros from the currently-in-use adapter or one of its dependencies, rather than all installed adapters in the namespace.
adapter_macro
is no longer a macro and will raise a deprecation warning. Useadapter.dispatch
instead.
Data tests
- Data tests are written as CTEs instead of subqueries. Adapter plugins for databases that don't support CTEs may need to override this behavior.
Python requirements
- Upgraded
snowflake-connector-python
dependency to 2.2.10 and enabled the SSO token cache
New features
For more details, see new and changed documentation below.
There are several pieces of net-new functionality in v0.18.0, with iterative improvements to come. If you encounter unexpected behavior, please post in Slack or open an issue.
Node selection
- methods:
config
,test_type
,test_name
,package
, [β]state
- intersections
- nth-parent/child
- [β] version-controlled YAML selectors
- [β] defer unselected node references to state defined by a previous run's artifacts
Adapter macros
adapter.dispatch
replacesadapter_macro
, with much greater flexibility- Schema tests are now defined via
dispatch
, such that non-core plugins can override schema test definitions
Docs
- Include static assets (such as images) in auto-generated docs site
- Improved resource search
- Project-level overviews
Database-specific
- Specify IAM profile when connecting to Redshift
- Snowflake query tags at connection and model level
- Impersonate a BigQuery service account when connecting via oauth
- Adding policy tags to BigQuery columns
- Configure time-to-live for BigQuery tables
New and changed documentation
Core
- node selection syntax
- list (ls)
- defer
- adapter.dispatch
asset-paths
config (also updated dbt_project.yml and description)- flag for colorized logs
full_refresh
config
Docs
Redshift
Snowflake
query_tag
in profile, model config- automatic SSO session caching support
BigQuery
0